Incorrect results might be generated when the following events occur:

• You are using explicit pass-through to access DB2
• You set the READBUFF= option to something greater than 1 in your CONNECT TO DB2 statement
• You are retrieving at least 1 variable defined as a DECIMAL data type in DB2
• Your query includes an ORDER BY clause outside of the pass-through part of the query

The only workarounds are to either set the READBUFF=1, move the ORDER BY inside the pass-through part of the query, or sort the data in a subsequent step.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at: